Clear Range
AutomatR.GoogleSheets.Activities.ClearRange
The "Clear Range" activity in AutomatR for Google Sheets allows users to clear the values within a specified range of cells in a Google Sheet. This activity aids in the efficient management of data by providing the capability to remove existing values within the designated range.
Properties
| Name | Description |
|---|---|
| Input | |
| Range | Specifies the range of cells that need to be cleared in the Google Sheet. String variables containing the cell range, such as "A1:B5". |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Clear Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
The "Clear Range" activity does not have specific output properties. However, it visually represents the success or failure of the clearing operation within the workflow.
How to Use
- Drag and drop the "Clear Range" activity onto the workflow.
- Configure the properties by specifying the range of cells to be cleared in the Google Sheet.
- Optionally, configure the delay and customize the display name.
- Execute the workflow to clear the values within the specified range of cells in the Google Sheet.
Example
Consider an example where the "Clear Range" activity is used to clear values in the range "A1:B5" of a Google Sheet:
Clear Range:
Display Name: "Clear Data"
Range: "A1:B5"
Delay: 2
In this example, the activity clears the values within the range "A1:B5" of the Google Sheet. The delay is set to 2 seconds to allow for proper synchronization.